SQL для тестировщика

Даны следующие таблицы:

Customers

| CustomerID |   Name   |     City      |
|------------|----------|---------------|
|     1      |   John   |   New York    |
|     2      |   Jane   |   Chicago     |
|     3      |   Mark   | Los Angeles   |
|     4      |   Sarah  | San Francisco |
|     5      |  Michael |   Houston     |

Orders

| OrderID | CustomerID |  OrderDate | TotalAmount |
|---------|------------|------------|-------------|
|    1    |     1      | 2022-05-15 |    500      |
|    2    |     2      | 2022-06-20 |    750      |
|    3    |     3      | 2022-06-25 |    1000     |
|    4    |     1      | 2022-07-10 |    300      |
|    5    |     4      | 2022-08-05 |    900      |

Какой из следующих SQL запросов вернет имена покупателей, разместивших как минимум 2 заказа?

A)

SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT(*) >= 2)

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerID HAVING COUNT(*) >= 2

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE COUNT(*) >= 2

D) SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders WHERE COUNT(*) >= 2)

www.tg-me.com/ru/SQL для тестировщика/com.sql_for_qa/113

2.5K viewsJun 21, 2023 at 12:11

tg-me.com/sql_for_qa/113

Create: 2023-06-21
Last Update: 2025-07-04 07:57:26

Даны следующие таблицы:

Customers

| CustomerID |   Name   |     City      |
|------------|----------|---------------|
|     1      |   John   |   New York    |
|     2      |   Jane   |   Chicago     |
|     3      |   Mark   | Los Angeles   |
|     4      |   Sarah  | San Francisco |
|     5      |  Michael |   Houston     |

Orders

| OrderID | CustomerID |  OrderDate | TotalAmount |
|---------|------------|------------|-------------|
|    1    |     1      | 2022-05-15 |    500      |
|    2    |     2      | 2022-06-20 |    750      |
|    3    |     3      | 2022-06-25 |    1000     |
|    4    |     1      | 2022-07-10 |    300      |
|    5    |     4      | 2022-08-05 |    900      |

Какой из следующих SQL запросов вернет имена покупателей, разместивших как минимум 2 заказа?

A)

SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT(*) >= 2)

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerID HAVING COUNT(*) >= 2

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE COUNT(*) >= 2

D) SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders WHERE COUNT(*) >= 2)

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/113

SQL для тестировщика Telegram | DID YOU KNOW?

Find Channels On Telegram?

How to Use Bitcoin?